UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SLHnpWGpWHwS1OL6YGAuXdw0DHSVd/9enoFooKBgzYs='
WHERE
key_id = '7ef52ce3a2a1888729f0143d314a82762e23234048336a5217c3d34fb3c36bb6'
AND (
token = 'SLHnpWGpWHwS1OL6YGAuXdw0DHSVd/9enoFooKBgzYs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)