UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ec297zZS5KP8q/grCoJvPhMDkUez9KHcMoi3ieUs9HQ='
WHERE
key_id = '0bc4fcaeb7c2d862b167fd3eecb71b261718fe7a9936770ec31552d2a329add0'
AND (
token = 'ec297zZS5KP8q/grCoJvPhMDkUez9KHcMoi3ieUs9HQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)