UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zPgAvbZ6A0YjAoMVVZRIh0Tpzby5vQrRHIA9cUcdcms='
WHERE
key_id = '378b2983a96380d09fbce433c688b209ee3f33d9966b1013aa0b7b1e42445d66'
AND (
token = 'zPgAvbZ6A0YjAoMVVZRIh0Tpzby5vQrRHIA9cUcdcms='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)