UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H0CujTcE57tbipXxV78y1JHao6AUNeBIrZ1ZXh7n0Xg='
WHERE
key_id = '8e006ed0c5fac5b74ce0fb1ef1cc7fe1f978dba9c0736449f8559db608208f6d'
AND (
token = 'H0CujTcE57tbipXxV78y1JHao6AUNeBIrZ1ZXh7n0Xg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)