UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W/HTQ5lYgjGrSk49CIKgRXjwMnaec+KzGNSITLive0c='
WHERE
key_id = '1b8e5218861b0dd305c5add314bda410c45d1e00d6930b1f084265c48d6380e6'
AND (
token = 'W/HTQ5lYgjGrSk49CIKgRXjwMnaec+KzGNSITLive0c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)