UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z3AKgjtUoZLE/4uALEaaNQi8Av3YpQpwIza1Z5s59qg='
WHERE
key_id = 'b6a3a2c343e662502ab4ba41bef32857af0e5d16929d3e33ce5506f11a3b4e65'
AND (
token = 'Z3AKgjtUoZLE/4uALEaaNQi8Av3YpQpwIza1Z5s59qg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)