UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yN+sSzmx2IlGfQolKzDzlbQbs3TyFJewn7P+RYt1tTo='
WHERE
key_id = 'bc0459308f3a1fcebc2aa54c7fd0e0324f7ccc850aa7079ff144a3e8ed79d4d9'
AND (
token = 'yN+sSzmx2IlGfQolKzDzlbQbs3TyFJewn7P+RYt1tTo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)