UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hp7a0TcgLjRF5es/wBsDbsg22HzQ6OVlok4AbUUy2lQ='
WHERE
key_id = '6a9bd9cc2c74503ec3b95e1a431d47c0510e592e249c7514f64a5a8c20d52f18'
AND (
token = 'hp7a0TcgLjRF5es/wBsDbsg22HzQ6OVlok4AbUUy2lQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)