UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nCVNDJC3OOYdhPV0UKlR056UfPpfgqyS8G+iD+clRYk='
WHERE
key_id = 'ef3cb9e47084fdb360cbac6132b456eade5d876e74eb2d3bebd78877bd1f93b4'
AND (
token = 'nCVNDJC3OOYdhPV0UKlR056UfPpfgqyS8G+iD+clRYk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)