UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uW8ryfV4H9ZazUZ2tRaJrfygm58RzuukMs15WE6rpDE='
WHERE
key_id = 'c972dfed10453e64a9bb82a4208d1719dac7881c1c214d59ce156f2f9b59d193'
AND (
token = 'uW8ryfV4H9ZazUZ2tRaJrfygm58RzuukMs15WE6rpDE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)