UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KIHD5dW1fucOsVC/osKkw450aHcu9T6j324uUfirwT0='
WHERE
key_id = '9586635503de473a840c734a905c5db25d3ecf1105658898cdcb85665a7ef8f5'
AND (
token = 'KIHD5dW1fucOsVC/osKkw450aHcu9T6j324uUfirwT0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)