UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xhr+bxAe0BZJGSyLOnHa0mf4QSgilVy/i0HaEZ8Aacc='
WHERE
key_id = '1433fec5451c31d659fb35c0201747e7c53c754797808f5ca2968253291c0b72'
AND (
token = 'xhr+bxAe0BZJGSyLOnHa0mf4QSgilVy/i0HaEZ8Aacc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)