UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4cD0ucgs/jGpVn7a9idBI5SGGZ0flLl43Hn2jb9Cf+c='
WHERE
key_id = '105048be736e3723fbd3ac389e276529334199f7b3b1361a1ae966dce841c4f0'
AND (
token = '4cD0ucgs/jGpVn7a9idBI5SGGZ0flLl43Hn2jb9Cf+c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)