UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bSfZuQWDt0I9vF44QAhVilR56L/snD6ShHP1GxxxW10='
WHERE
key_id = 'afe97e371c5eac7c89b591d20b9809ab5d8d2602f87c5141a5e33c4f428cea02'
AND (
token = 'bSfZuQWDt0I9vF44QAhVilR56L/snD6ShHP1GxxxW10='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)