UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'im+za6PCA5ON92wbWitab6GsCNdnGrdMRHHpjQj7uD0='
WHERE
key_id = 'e9ba8c56e26fb11b4ffc71768982f7675886655913817d0234be8220f465a170'
AND (
token = 'im+za6PCA5ON92wbWitab6GsCNdnGrdMRHHpjQj7uD0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)