UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zABMSk45955xBAI+iga3w4l9j9Ru0lkyfIg/C9IqIj4='
WHERE
key_id = '71dbca8bafef72e2dc0ffb7a634859d844605320c09f47931527884fd59c9296'
AND (
token = 'zABMSk45955xBAI+iga3w4l9j9Ru0lkyfIg/C9IqIj4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)