UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k07DzK10zcz2Y+KpMk+CyiolyoUbPVjGCEEW7G6LN4k='
WHERE
key_id = 'bd82b78f2dd0ddda8c6a22648978aab60987ce1fc999666f6daac6f582575273'
AND (
token = 'k07DzK10zcz2Y+KpMk+CyiolyoUbPVjGCEEW7G6LN4k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)