UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SKNto9Pke89IV3yJTzNKtKIHf0y1kXcGCXmuYgvF6F4='
WHERE
key_id = '5d7751531f6c821a72045bca102a51604bb2a3d97876c54c4e4203d881efb6fe'
AND (
token = 'SKNto9Pke89IV3yJTzNKtKIHf0y1kXcGCXmuYgvF6F4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)