UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A6mHxc1oV8EHIfZTBt9fMCwgfkacUt4zY8udd44zXg4='
WHERE
key_id = '384b588a5ccc6d04a447424880e12b30113e744a98bd6afaae9945d1a74d54e2'
AND (
token = 'A6mHxc1oV8EHIfZTBt9fMCwgfkacUt4zY8udd44zXg4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)