UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Hbt4vY3cy56YDNguoF+q5cKSTxa5mz9P8IJ+Yp0R2jQ='
WHERE
key_id = 'aa9c8ae5e6fd905fdc5f8451b3c48d5da94c212951d6444f7a8fb15bd66d74b6'
AND (
token = 'Hbt4vY3cy56YDNguoF+q5cKSTxa5mz9P8IJ+Yp0R2jQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)