UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MXfVc0JOK6g/PbwRWyfBFI3JQwy2oU5mkj+6QyhZJLA='
WHERE
key_id = '01847d84df7d3ec39ab6e790180bfe0508d10347833ba44e210393ab931f1864'
AND (
token = 'MXfVc0JOK6g/PbwRWyfBFI3JQwy2oU5mkj+6QyhZJLA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)