UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7o0YXiMaWNnDYnlf734d6ma8RQQE3bixaG91hJH6Fs8='
WHERE
key_id = '8474e72be739cdd864ec53a157c3826d163533a0a0243734fe0f2b84bdc34323'
AND (
token = '7o0YXiMaWNnDYnlf734d6ma8RQQE3bixaG91hJH6Fs8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)