UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'h7Gp96rZ2HCh0j65wnJm3MG5MI07QTXvRJETS7bkl1k='
WHERE
key_id = '827741197b6287bb053d250c3f74f3b10db654cf69ca161886971679ca5da766'
AND (
token = 'h7Gp96rZ2HCh0j65wnJm3MG5MI07QTXvRJETS7bkl1k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)