UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ha1RyTLjkVDcB9Oqze0aGVdDKePj2PKmz4aR1rrRfHA='
WHERE
key_id = '2b3e0207544f4fd083b340874c5150f5a696006f481e3f5a41839fae814fdc46'
AND (
token = 'Ha1RyTLjkVDcB9Oqze0aGVdDKePj2PKmz4aR1rrRfHA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)