UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'phWh4SXJf64graUJXp6D+R7rS5dgxYufWFLVQJ+XVkc='
WHERE
key_id = '1e6b7fc65c53ab9136b58cd806f722bd7c288a3d441c38f28423bafb4a542891'
AND (
token = 'phWh4SXJf64graUJXp6D+R7rS5dgxYufWFLVQJ+XVkc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)