UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VphXuk5/gsCB0wnKa2iLsgsZJQSkWH54skWn35MZodo='
WHERE
key_id = 'bfb49919635907f33217f4a6a63d3383c2024551a8f863de4ebeeaf73c7196ef'
AND (
token = 'VphXuk5/gsCB0wnKa2iLsgsZJQSkWH54skWn35MZodo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)