UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n+Iia0rERdDXdnEo9HOHx2MJoPDPmrYTqH/xJU975Vo='
WHERE
key_id = 'ac36d4581398578fd3d80fcee25ce59c8a65139d9c257dc3d49435ca8ef67f4e'
AND (
token = 'n+Iia0rERdDXdnEo9HOHx2MJoPDPmrYTqH/xJU975Vo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)